package com.example.demo.mapper;

import com.example.demo.dao.Executive;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface ExecutiveInfoMapper extends JpaRepository<Executive, Integer> {

    /**
     * 查询全部高管基本信息
     * @return
     */
    List<Executive> findAllByCompanyCode(String companyCode);

    /**
     * 根据高管编号查询高管详细信息
     * @return
     */
    Executive findByExecutiveCode(String code);

    /**
     * 根据高管编号删除高管信息
     * @return
     */
    Integer deleteByExecutiveCode(String code);


}
